Question on libpq.so

--0-509622779-1231461277=:37017
Content-Type: text/plain; charset=iso-8859-1
Content-Transfer-Encoding: quoted-printable

We are in the process of upgrading our postgres database from 7.4 to 8.2 on=
Redhat ES4 server.=A0 Postgresql uses libpq.so.5.0, while libpq.so.3 was i=
nitially installed and=A0is needed by php.=A0 I did the postgresql 8.2.10 i=
nstallation without dependency:=0Arpm -Uvh --nodeps postgresql-*.rpm=0AThen=
I try to recompile PHP 4.3.9 rpm, hoping that it will point to the new pos=
tgres so.=A0 The compilation failed with the error: =0AUnable to load dynam=
ic library '/usr/lib/php4/pgsql.so' - libpq.so.3: cannot open shared object=
file: No such file or directory in Unknown on line 0 Can PHP 4.3 work=
with postgresql 8.2, and how can I point PHP rpm to use libpq.so.5?=A0 Tha=
nks. =0ALawrence =0A
--0-509622779-1231461277=:37017
Content-Type: text/html; charset=us-ascii

Re: Question on libpq.so

On Thursday 08 January 2009, "L. Zhao" wrote:
> new postgres so.  The compilation failed with the error: Unable to l=
oad
> dynamic library '/usr/lib/php4/pgsql.so' - libpq.so.3: cannot open shared
> object file: No such file or directory in Unknown on line 0

That appears to be a runtime message, not a compile error. Did the=20
compilation system have only the new PostgreSQL installed? What does rpm=20
show for dependencies for your new RPMs? Did you actually install the new=
=20
RPMs?

--=20
Current Peeve: The mindset that the Internet is some sort of school for
novice sysadmins and that everyone -not- doing stupid dangerous things
should act like patient teachers with the ones who are. -- Bill Cole, NANAE=
=20

--=20
Sent via pgsql-php mailing list (pgsql-php@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-php

Re: Question on libpq.so

L. Zhao wrote:
> We are in the process of upgrading our postgres database from 7.4 to 8.2
> on Redhat ES4 server. Postgresql uses libpq.so.5.0, while libpq.so.3
> was initially installed and is needed by php. I did the postgresql
> 8.2.10 installation without dependency:
> rpm -Uvh --nodeps postgresql-*.rpm

Was there a reason why you had to use --nodeps? Exactly which rpms did
you install?

> Then I try to recompile PHP 4.3.9 rpm, hoping that it will point to the
> new postgres so. The compilation failed with the error:
> Unable to load dynamic library '/usr/lib/php4/pgsql.so' - libpq.so.3:
> cannot open shared object file: No such file or directory in Unknown on
> line 0

As Alan pointed out, this is a runtime error not a compile error. How
did you rebuild the php 4.3.9 rpm? Any errors during that process?

> Can PHP 4.3 work with postgresql 8.2, and how can I point PHP rpm to use
> libpq.so.5? Thanks.

Once you have it compiled properly it should work fine.

--
Postgresql & php tutorials
http://www.designmagick.com/


--
Sent via pgsql-php mailing list (pgsql-php@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-php

Re: Question on libpq.so

--0-1115237705-1231521948=:83424
Content-Type: text/plain; charset=iso-8859-1
Content-Transfer-Encoding: quoted-printable

The server had postgres 7.4 installed, when I tried to upgrade to 8.2.10, I=
got error on failed dependencies:=0Arpm -Uvh --test postgresql-*.rpm=0Aerr=
or: Failed dependencies:         libpq.so.3 is needed by (i=
nstalled) mod_auth_pgsql-2.0.1-7.1.i386         libpq.so.3 =
is needed by (installed) perl-DBD-Pg-1.31-6.i386         li=
bpq.so.3 is needed by (installed) libdbi-dbd-pgsql-0.6.5-10.RHEL4.1.i386=0A=
      =A0 libpq.so.3 is needed by (installed) freeradius-postgr=
esql-1.0.1-3.RHEL4.5.i386         libpq.so.3 is needed by (=
installed) postgresql-tcl-7.4.19-1.el4_6.1.i386         lib=
pq.so.3 is needed by (installed) cyrus-sasl-sql-2.1.19-14.i386    =
     libpq.so.3 is needed by (installed) postgresql-python-7.4.19-1=
..el4_6.1.i386         libpq.so.3 is needed by (installed) q=
t-PostgreSQL-3.3.3-13.RHEL4.i386         libpq.so.3 is need=
ed by (installed) dovecot-0.99.11-9.EL4.i386         libpq.=
so.3 is needed by (installed) php-pgsql-4.3.9-3.22.12.i386 =0AThat is =
why I use the --nodeps, expecting that I will rebuild php rpm afterwards.=
=0Arpm -Uvh --nodeps postgresql-*.rpm=0APreparing...      =A0=
         ########################################### [100%]=
 =A0 1:postgresql-test      =A0 ##########################=
################# [=A0 9%]  =A0 2:postgresql        =A0=
  =A0 ########################################### [ 18%]  =A0 3:pos=
tgresql-contrib     ########################################### [ 2=
7%]  =A0 4:postgresql-debuginfo   #################################=
########## [ 36%]  =A0 5:postgresql-devel       ###########=
################################ [ 45%]  =A0 6:postgresql-docs  =A0=
     ########################################### [ 55%]  =A0 7:=
postgresql-libs      =A0 ######################################=
##### [ 64%]  =A0 8:postgresql-plperl    =A0 ##################=
######################### [ 73%]  =A0 9:postgresql-plpython  =A0 ##=
######################################### [ 82%]   10:postgresql-pltcl=
       ########################################### [ 91%]  =
11:postgresql-server    =A0 ######################################=
##### [100%] When I tried to rebuild PHP rpms, which is php 4.3.9 on E=
S4.=A0 It failed:=0A......=0A001+ PHP Warning:=A0 Unknown(): Unable to load=
dynamic library '/usr/lib/php4/pgsql.so' - libpq.so.3: cannot open shared =
object file: No such file or directory in Unknown on line 0=0A002- md5(line=
1)=3D e84debf3a1d132871d7fe45c1c04c566 (length 20000)=0A002+ md5(line 0)=
=3D e86410fa2d6e2634fd8ac5f4b3afe7f3 (length 10)=0A003- md5(line 2)=3D c33b=
4d2f86908eea5d75ee5a61fd81f4 (length 10000)=0A003+ md5(line 1)=3D e84debf3a=
1d132871d7fe45c1c04c566 (length 20000)=0A004- md5(line 3)=3D 2ecdde3959051d=
913f61b14579ea136d (length 5)=0A004+ md5(line 2)=3D c33b4d2f86908eea5d75ee5=
a61fd81f4 (length 10000)=0A005- md5(line 4)=3D c33b4d2f86908eea5d75ee5a61fd=
81f4 (length 10000)=0A005+ md5(line 3)=3D 2ecdde3959051d913f61b14579ea136d =
(length 5)=0A006- md5(line 5)=3D 902fbdd2b1df0c4f70b4a5d23525e932 (length 3=
)=0A006+ md5(line 4)=3D c33b4d2f86908eea5d75ee5a61fd81f4 (length 10000)=0A0=
07+ md5(line 5)=3D 902fbdd2b1df0c4f70b4a5d23525e932 (length 3)=0A<< ../ext/=
standard/tests/file/bug26938.diff result ends.=0Aerror: Bad exit status fro=
m /var/tmp/rpm-tmp.12911 (%check) RPM build errors:     Bad ex=
it status from /var/tmp/rpm-tmp.12911 (%check) I look into php.spec, i=
t does not specify the usage of libpq.so.3.=A0 So I am wondering why librar=
y pgsql.so requires libpq.so.3, and if there is any compatibility issue.=0A=
=0AThanks. =0A________________________________=0A From: Chris agick@gmail.com>=0ATo: L. Zhao =0ACc: pgsql-php@postgres=
ql.org=0ASent: Thursday, January 8, 2009 6:45:33 PM=0ASubject: Re: [PHP] Qu=
estion on libpq.so L. Zhao wrote:=0A> We are in the process of upgradi=
ng our postgres database from 7.4 to 8.2 on Redhat ES4 server.=A0 Postgresq=
l uses libpq.so.5.0, while libpq.so.3 was initially installed and is needed=
by php.=A0 I did the postgresql 8.2.10 installation without dependency:=0A=
> rpm -Uvh --nodeps postgresql-*.rpm Was there a reason why you had to=
use --nodeps? Exactly which rpms did you install? > Then I try to rec=
ompile PHP 4.3.9 rpm, hoping that it will point to the new postgres so.=A0 =
The compilation failed with the error:=0A> Unable to load dynamic library '=
/usr/lib/php4/pgsql.so' - libpq.so.3: cannot open shared object file: No su=
ch file or directory in Unknown on line 0 As Alan pointed out, this is=
a runtime error not a compile error. How did you rebuild the php 4.3.9 rpm=
? Any errors during that process? > Can PHP 4.3 work with postgresql 8=
..2, and how can I point PHP rpm to use libpq.so.5?=A0 Thanks. Once you=
have it compiled properly it should work fine. -- Postgresql & php tu=
torials=0Ahttp://www.designmagick.com/ =0A-- Sent via pgsql-php mailin=
g list (pgsql-php@postgresql.org)=0ATo make changes to your subscription:=
=0Ahttp://www.postgresql.org/mailpref/pgsql-php
--0-1115237705-1231521948=:83424
Content-Type: text/html; charset=us-ascii

Re: Question on libpq.so

On Friday 09 January 2009, "L. Zhao" wrote:
> RPM build errors:
>     Bad exit status from /var/tmp/rpm-tmp.12911 (%check)
>
> I look into php.spec, it does not specify the usage of libpq.so.3.  =
So I
> am wondering why library pgsql.so requires libpq.so.3, and if there is
> any compatibility issue.

It looks like the test suite run during the RPM creation is trying to load=
=20
the currently installed PHP pgsql.so library instead of the one just=20
compiled. You could try just commenting out the test options in the RPM=20
spec file.

--=20
Current Peeve: The mindset that the Internet is some sort of school for
novice sysadmins and that everyone -not- doing stupid dangerous things
should act like patient teachers with the ones who are. -- Bill Cole, NANAE=
=20

--=20
Sent via pgsql-php mailing list (pgsql-php@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-php

Re: Question on libpq.so

--0-1075829546-1231525701=:46602
Content-Type: text/plain; charset=iso-8859-1
Content-Transfer-Encoding: quoted-printable

I am not familiar with the structure of php.spec.=A0 What should I look for=
regarding the test suite run?=A0 Thanks. =0A___________________=
_____________=0AFrom: Alan Hodgson =0ATo: pgsql-php@pos=
tgresql.org=0ASent: Friday, January 9, 2009 9:42:52 AM=0ASubject: Re: [PHP]=
Question on libpq.so On Friday 09 January 2009, "L. Zhao" hoo.com> wrote:=0A> RPM build errors:=0A>   =A0 Bad exit status from /v=
ar/tmp/rpm-tmp.12911 (%check)=0A>=0A> I look into php.spec, it does not spe=
cify the usage of libpq.so.3.=A0 So I=0A> am wondering why library pgsql.so=
requires libpq.so.3, and if there is=0A> any compatibility issue. It =
looks like the test suite run during the RPM creation is trying to load =0A=
the currently installed PHP pgsql.so library instead of the one just =0Acom=
piled. You could try just commenting out the test options in the RPM =0Aspe=
c file. -- =0ACurrent Peeve: The mindset that the Internet is some sor=
t of school for=0Anovice sysadmins and that everyone -not- doing stupid dan=
gerous things=0Ashould act like patient teachers with the ones who are. -- =
Bill Cole, NANAE -- =0ASent via pgsql-php mailing list (pgsql-php@pos=
tgresql.org)=0ATo make changes to your subscription:=0Ahttp://www.postgresq=
l.org/mailpref/pgsql-php
--0-1075829546-1231525701=:46602
Content-Type: text/html; charset=us-ascii

Re: Question on libpq.so

------_=_NextPart_001_01C97499.37BF9C1D
Content-Type: text/plain; charset="us-ascii"
Content-Transfer-Encoding: quoted-printable

I suggest you try to see if there is a compatibility rpm you need to
install.=20

=20

Kind regards, Bernt

=20

From: pgsql-php-owner@postgresql.org
[mailto:pgsql-php-owner@postgresql.org] On Behalf Of L. Zhao
Sent: Friday, January 09, 2009 7:28 PM
To: pgsql-php@postgresql.org
Subject: Re: [PHP] Question on libpq.so

=20

I am not familiar with the structure of php.spec. What should I look
for regarding the test suite run? Thanks.

=20

________________________________

From: Alan Hodgson
To: pgsql-php@postgresql.org
Sent: Friday, January 9, 2009 9:42:52 AM
Subject: Re: [PHP] Question on libpq.so

On Friday 09 January 2009, "L. Zhao" wrote:
> RPM build errors:
> Bad exit status from /var/tmp/rpm-tmp.12911 (%check)
>
> I look into php.spec, it does not specify the usage of libpq.so
.3. So I
> am wondering why library pgsql.so requires
libpq.so.3, and if there is
> any compatibility issue.

It looks like the test suite run during the RPM creation is trying to
load=20
the currently installed PHP pgsql.so library instead of the one just=20
compiled. You could try just commenting out the test options in the RPM=20
spec file.

--=20
Current Peeve: The mindset that the Internet is some sort of school for
novice sysadmins and that everyone -not- doing stupid dangerous things
should act like patient teachers with the ones who are. -- Bill Cole,
NANAE=20

--=20
Sent via pgsql-php mailing list (pgsql-php@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-php

=20


------_=_NextPart_001_01C97499.37BF9C1D
Content-Type: text/html; charset="us-ascii"
Content-Transfer-Encoding: quoted-printable

xmlns:o=3D"urn:schemas-microsoft-com:office:office" =
xmlns:w=3D"urn:schemas-microsoft-com:office:word" =
xmlns:m=3D"http://schemas.microsoft.com/office/2004/12/omml" =
xmlns=3D"http://www.w3.org/TR/REC-html40">


charset=3Dus-ascii">